SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 57250: A CalcPlug KPI that depends on a roll-up KPI might not calculate at the roll-up level in SAS® Merchandise Planning

DetailsAboutRate It

In SAS Merchandise Planning, a CalcPlug KPI that depends on a roll-up field might not be calculated at the roll-up level when an edit happens at the higher level. For example, consider a worksheet that is built with one merchandise member, one location member, and time set for one month to week. When you edit KPI_1 at the month level, a roll-up field called KPI_2 changes at the month and week levels as expected. However, the Calc field dependent on this change, KPI_3, only changes at the month level and the week values do not recalculate.

The workaround for this issue is to change the aggregation rule of KPI from CalcPlug to Calc/Calc/Calc.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Merchandise Financial Planning and SAS Merchandise In-Season Management64-bit Enabled AIX6.5_M16.69.4 TS1M29.4 TS1M3
Microsoft Windows Server 2008 for x646.5_M16.69.4 TS1M29.4 TS1M3
Linux for x646.5_M16.69.4 TS1M29.4 TS1M3
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.